---
title: SAIF.Business.Claim database tables
summary: Database tables used by this library with relationships and usage context.
status: draft
owner: SAIF Documentation Generator
last_reviewed: 2026-08-21
library: SAIF.Business.Claim
reference_type: embedded
---

# SAIF.Business.Claim database tables

This page catalogs database tables accessed by this library. All tables are Oracle; schema qualification could not be resolved from any `*.config` file in the repository (see per-table Schema/Link notes).**

## Table catalog

| Table | Database | Schema/Link | CRUD | Purpose | Primary business object |
| --- | --- | --- | --- | --- | --- |
| [CL_1502_DCBS_TRANSFER](#cl_1502_dcbs_transfer) | Oracle | `[unqualified]**` (UPDATE only: `CLM_DBA`) | C, R, U, D | DCBS 1502 transfer file lifecycle | `cls1502Transfer` |
| [CL_AWARD](#cl_award) | Oracle | `[unqualified]**` | R, U | Award status and pending processing | `clsSetAwardPaymentPending` |
| [CL_BENEFIT_PAYMENT](#cl_benefit_payment) | Oracle | `[unqualified]**` | R, U, D | Benefit payment rows for schedules and awards | `clsAwardBenefitPayment` |
| [CL_BENEFIT_SCHEDULE](#cl_benefit_schedule) | Oracle | `[unqualified]**` | R, U, D | Active/federal benefit schedule rows | `clsActiveBenefitSchedule` |
| [CL_CLAIM_EMPLOYEE_WORK_ADDRESS](#cl_claim_employee_work_address) | Oracle | `[unqualified]**` | C, R, U, D | Employee work address for a claim | `clsClaimEmployeeWorkAddress` |
| [CL_CLAIM_WORK_RELEASE_STATUS](#cl_claim_work_release_status) | Oracle | `[unqualified]**` | C, R, U, D | Work-release status history | `clsClaimWorkReleaseStatus` |
| [CL_CLAIM_WORK_STATUS](#cl_claim_work_status) | Oracle | `[unqualified]**` | C, R, U, D | Return-to-work status history | `clsClaimWorkStatus` |
| [CL_FEDERAL_AWARD](#cl_federal_award) | Oracle | `[unqualified]**` | R, U | Federal award status | `clsFederalAwardStatus` |
| [CL_INJURY_CLAIM](#cl_injury_claim) | Oracle | `[unqualified]**` | R (join), U | Claim-level injury record; primary body-part propagation target | `clsWorkerInjuredBodyPart` |
| [CL_PPD_BODY_PART_CODE](#cl_ppd_body_part_code) | Oracle | `[unqualified]**` | R | PPD body-part reference code table | `clsPPDBodyParts` |
| [CL_PPD_SCHED_DEGREE_AWARD](#cl_ppd_sched_degree_award) | Oracle | `[unqualified]**` | R | PPD scheduled degree-award amounts | `clsPPDScheduledDegreeAwards` |
| [CL_PPD_UNSCHED_DEGREE_AWARD](#cl_ppd_unsched_degree_award) | Oracle | `[unqualified]**` | R | PPD unscheduled degree-award bands | `clsPPDUnscheduledDegreeAwards` |
| [CL_RESERVE_MED_SERV_TYPE_CODE](#cl_reserve_med_serv_type_code) | Oracle | `[unqualified]**` | R | Medical reserve service-type reference codes | `clsServiceTypeCollection` |
| [CL_RESERVE_MED_SERV_DESCR_CODE](#cl_reserve_med_serv_descr_code) | Oracle | `[unqualified]**` | R | Medical reserve service description codes | `clsServiceTypeCollection` |
| [CL_RESERVE_VOC_SERV_COST_CODE](#cl_reserve_voc_serv_cost_code) | Oracle | `[unqualified]**` | R | Vocational reserve service-cost reference codes | `clsServiceTypeCollection` |
| [CL_RESERVE_VOC_SERV_DESCR_CODE](#cl_reserve_voc_serv_descr_code) | Oracle | `[unqualified]**` | R | Vocational reserve service description codes | `clsServiceTypeCollection` |
| [CL_RESERVE_VOC_SERV_TYPE_CODE](#cl_reserve_voc_serv_type_code) | Oracle | `[unqualified]**` | R | Vocational reserve service-type reference codes | `clsVocationalServiceTypes` |
| [CL_WORKER_INJURED_BODY_PART](#cl_worker_injured_body_part) | Oracle | `[unqualified]**` | C, R, U, D | Injured body-part rows for a claim | `clsWorkerInjuredBodyPart` |

`DUAL` is excluded as an Oracle pseudo-table (used only by the three sequence reads, SQL-001/002/003).

## CL_1502_DCBS_TRANSFER

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | `[unqualified]**` on INSERT/DELETE/SELECT; `CLM_DBA` on UPDATE only — an inconsistency flagged for follow-up.* |
| **Purpose** | Stores DCBS 1502 transfer file records queued for transfer and their processed status. |
| **Access pattern** | Direct SQL (criteria pattern plus two literal `SELECT` helper functions) |
| **CRUD operations** | Create, Read, Update, Delete |
| **Key columns used** | FILE_ID, CLAIM_ID, PROCESSED_DATE, FILE_NAME |
| **Sequence** | CL_1502_DCBS_TRANSFER_SEQ |
| **Related tables** | CL_INJURY_CLAIM (inferred, by CLAIM_ID) |
| **Business objects** | `cls1502Transfer`, `cls1502TransferList` |

### Operations referencing this table
- [DCBS 1502 transfer handling](operations/1502-transfer.md)

### Business rules referencing this table
- [BR-001: 1502 transfer claim ID required](business-rules.md#br-001-1502-transfer-claim-id-required)
- [BR-002: 1502 transfer filing reason required](business-rules.md#br-002-1502-transfer-filing-reason-required)

### SQL referencing this table
- [SQL-001: Get next 1502 transfer sequence value](sql/SQL-001.md)
- [SQL-004: Insert a new 1502 DCBS transfer record](sql/SQL-004.md)
- [SQL-009: Retrieve unprocessed 1502 transfers for a claim](sql/SQL-009.md)
- [SQL-010: Retrieve all unprocessed 1502 transfers](sql/SQL-010.md)
- [SQL-037: Update a 1502 DCBS transfer as processed](sql/SQL-037.md)
- [SQL-052: Delete a 1502 DCBS transfer record](sql/SQL-052.md)

---

## CL_AWARD

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | `[unqualified]**` |
| **Purpose** | Stores award records and their status, including the Pending lifecycle. |
| **Access pattern** | Direct SQL (criteria pattern) |
| **CRUD operations** | Read, Update |
| **Key columns used** | CLAIM_ID, SAIF_AWARD_NUM, AWARD_STATUS_CODE |
| **Sequence** | N/A |
| **Related tables** | CL_BENEFIT_PAYMENT (inferred, shared CLAIM_ID/SAIF_AWARD_NUM), CL_FEDERAL_AWARD |
| **Business objects** | `clsSetAwardPaymentPending` |

### Operations referencing this table
- [Set award to Pending](operations/award-pending.md)

### Business rules referencing this table
- [BR-011: Award must be successfully updated to pending](business-rules.md#br-011-award-must-be-successfully-updated-to-pending)

### SQL referencing this table
- [SQL-031: Retrieve an active award for pending processing](sql/SQL-031.md)
- [SQL-048: Set an award status to Pending](sql/SQL-048.md)

---

## CL_BENEFIT_PAYMENT

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | `[unqualified]**` |
| **Purpose** | Stores individual benefit payment rows linked to benefit schedules and awards. |
| **Access pattern** | Direct SQL (criteria pattern and auxiliary criteria-class SQL properties) |
| **CRUD operations** | Read, Update, Delete |
| **Key columns used** | CLAIM_ID, BENEFIT_PAYMENT_SEQ_NUM, SAIF_AWARD_NUM, BENEFIT_STATUS_CODE, BENEFIT_TYPE_CODE |
| **Sequence** | N/A |
| **Related tables** | CL_BENEFIT_SCHEDULE (inferred, identical key pair), CL_AWARD, CL_FEDERAL_AWARD |
| **Business objects** | `clsAwardBenefitPayment`, `clsAwardBenefitPaymentCollection`, `clsActiveBenefitSchedule`, `clsSetAwardPaymentPending` |

### Operations referencing this table
- [Benefit-payment stop processing](operations/benefit-payment-stop.md)
- [Set award to Pending](operations/award-pending.md)

### Business rules referencing this table
- [BR-009: Benefit schedule update must affect a row](business-rules.md#br-009-benefit-schedule-update-must-affect-a-row)
- [BR-010: Benefit payment delete must affect a row](business-rules.md#br-010-benefit-payment-delete-must-affect-a-row)
- [BR-011: Award must be successfully updated to pending](business-rules.md#br-011-award-must-be-successfully-updated-to-pending)
- [BR-012: Optimistic concurrency contention check](business-rules.md#br-012-optimistic-concurrency-contention-check)

### SQL referencing this table
- [SQL-012: Retrieve the benefit payment for an active schedule](sql/SQL-012.md)
- [SQL-014: Retrieve an in-progress award benefit payment](sql/SQL-014.md)
- [SQL-015: Retrieve award benefit payments by benefit type](sql/SQL-015.md)
- [SQL-032: Retrieve benefit payments for an award](sql/SQL-032.md)
- [SQL-039: Update remaining payment count on a benefit payment](sql/SQL-039.md)
- [SQL-040: Update an award benefit payment issue date](sql/SQL-040.md)
- [SQL-049: Move an award's benefit payment to In Progress](sql/SQL-049.md)
- [SQL-054: Delete a benefit payment (stop processing)](sql/SQL-054.md)
- [SQL-055: Delete an award benefit payment](sql/SQL-055.md)

---

## CL_BENEFIT_SCHEDULE

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | `[unqualified]**` |
| **Purpose** | Stores benefit-schedule rows tracking remaining payments and next issue dates. |
| **Access pattern** | Direct SQL (criteria pattern) |
| **CRUD operations** | Read, Update, Delete |
| **Key columns used** | CLAIM_ID, BENEFIT_PAYMENT_SEQ_NUM, NEXT_ISSUE_DATE, REMAINING_PAYMENT_COUNT |
| **Sequence** | N/A |
| **Related tables** | CL_BENEFIT_PAYMENT (inferred, identical key pair) |
| **Business objects** | `clsActiveBenefitSchedule`, `clsFederalBenefitSchedule` |

### Operations referencing this table
- [Benefit-payment stop processing](operations/benefit-payment-stop.md)

### Business rules referencing this table
- [BR-012: Optimistic concurrency contention check](business-rules.md#br-012-optimistic-concurrency-contention-check)

### SQL referencing this table
- [SQL-011: Retrieve an active benefit schedule row](sql/SQL-011.md)
- [SQL-024: Retrieve a federal benefit schedule row](sql/SQL-024.md)
- [SQL-038: Update an active benefit schedule](sql/SQL-038.md)
- [SQL-047: Update a federal benefit schedule](sql/SQL-047.md)
- [SQL-053: Delete an active benefit schedule](sql/SQL-053.md)
- [SQL-061: Delete a federal benefit schedule](sql/SQL-061.md)

---

## CL_CLAIM_EMPLOYEE_WORK_ADDRESS

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | `[unqualified]**` |
| **Purpose** | Stores an injured employee's work address for a claim. |
| **Access pattern** | Direct SQL (criteria pattern) |
| **CRUD operations** | Create, Read, Update, Delete |
| **Key columns used** | CLAIM_ID, ADDRESS_LINE_1_TEXT, CITY_NAME, STATE_CODE, ZIP_CODE, COUNTY_CODE |
| **Sequence** | N/A |
| **Related tables** | CL_INJURY_CLAIM (inferred, one-to-one by CLAIM_ID) |
| **Business objects** | `clsClaimEmployeeWorkAddress` |

### Business rules referencing this table
- [BR-012: Optimistic concurrency contention check](business-rules.md#br-012-optimistic-concurrency-contention-check)

### SQL referencing this table
- [SQL-005: Insert a new claim employee work address](sql/SQL-005.md)
- [SQL-018: Retrieve a claim employee work address](sql/SQL-018.md)
- [SQL-043: Update a claim employee work address](sql/SQL-043.md)
- [SQL-058: Delete a claim employee work address](sql/SQL-058.md)

---

## CL_CLAIM_WORK_RELEASE_STATUS

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | `[unqualified]**` |
| **Purpose** | Stores work-release status history for a claim. |
| **Access pattern** | Direct SQL (criteria pattern) |
| **CRUD operations** | Create, Read, Update, Delete |
| **Key columns used** | CLAIM_ID, CLAIM_WORK_REL_STATUS_SEQ_NUM, WORK_RELEASE_STATUS_CODE, EFFECTIVE_DATE |
| **Sequence** | CLAIM_WORK_REL_STATUS_SEQ_NUM |
| **Related tables** | CL_INJURY_CLAIM (inferred, by CLAIM_ID) |
| **Business objects** | `clsClaimWorkReleaseStatus` |

### Business rules referencing this table
- [BR-004: Work release date must be valid at level two](business-rules.md#br-004-work-release-date-must-be-valid-at-level-two)
- [BR-005: Work release status data must be present](business-rules.md#br-005-work-release-status-data-must-be-present)

### SQL referencing this table
- [SQL-002: Get next claim work-release-status sequence value](sql/SQL-002.md)
- [SQL-006: Insert a new claim work-release-status record](sql/SQL-006.md)
- [SQL-020: Retrieve the latest claim work-release-status row](sql/SQL-020.md)
- [SQL-044: Update a claim work-release-status row](sql/SQL-044.md)
- [SQL-059: Delete a claim work-release-status row](sql/SQL-059.md)

---

## CL_CLAIM_WORK_STATUS

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | `[unqualified]**` |
| **Purpose** | Stores return-to-work status history for a claim. |
| **Access pattern** | Direct SQL (criteria pattern) |
| **CRUD operations** | Create, Read, Update, Delete |
| **Key columns used** | CLAIM_ID, CLAIM_WORK_STATUS_SEQ_NUM, WORK_STATUS_CODE, EFFECTIVE_DATE |
| **Sequence** | CLAIM_WORK_STATUS_SEQ |
| **Related tables** | CL_INJURY_CLAIM (inferred, by CLAIM_ID) |
| **Business objects** | `clsClaimWorkStatus` |

### Business rules referencing this table
- [BR-003: Work status date cannot be in the future](business-rules.md#br-003-work-status-date-cannot-be-in-the-future)

### SQL referencing this table
- [SQL-003: Get next claim work-status sequence value](sql/SQL-003.md)
- [SQL-007: Insert a new claim work-status record](sql/SQL-007.md)
- [SQL-021: Retrieve the latest claim work-status row](sql/SQL-021.md)
- [SQL-045: Update a claim work-status row](sql/SQL-045.md)
- [SQL-060: Delete a claim work-status row](sql/SQL-060.md)

---

## CL_FEDERAL_AWARD

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | `[unqualified]**` |
| **Purpose** | Stores federal award records and their status. |
| **Access pattern** | Direct SQL (criteria pattern) |
| **CRUD operations** | Read, Update |
| **Key columns used** | CLAIM_ID, SAIF_AWARD_NUM, AWARD_STATUS_CODE |
| **Sequence** | N/A |
| **Related tables** | CL_INJURY_CLAIM (verified join), CL_BENEFIT_PAYMENT (inferred) |
| **Business objects** | `clsFederalAwardStatus`, `clsFederalAwardStatusCollection` |

### SQL referencing this table
- [SQL-022: Retrieve federal awards by claim and status](sql/SQL-022.md)
- [SQL-023: Retrieve federal awards by worker and status](sql/SQL-023.md)
- [SQL-046: Update a federal award status](sql/SQL-046.md)

---

## CL_INJURY_CLAIM

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | `[unqualified]**` |
| **Purpose** | Claim-level injury record; parent of most claim-scoped child tables in this library and the propagation target for the primary injured body part. |
| **Access pattern** | Direct SQL (legacy comma-join in one retrieve; criteria pattern for the update) |
| **CRUD operations** | Read (join), Update |
| **Key columns used** | CLAIM_ID, WORKER_ID, BODY_PART_CODE, BODY_PART_SIDE_CODE |
| **Sequence** | N/A |
| **Related tables** | CL_FEDERAL_AWARD (verified join), CL_WORKER_INJURED_BODY_PART, CL_CLAIM_WORK_STATUS, CL_CLAIM_WORK_RELEASE_STATUS, CL_CLAIM_EMPLOYEE_WORK_ADDRESS, CL_1502_DCBS_TRANSFER (all inferred, by CLAIM_ID) |
| **Business objects** | `clsFederalAwardStatusCollection`, `clsWorkerInjuredBodyPart` |

### Operations referencing this table
- [Injured body-part maintenance](operations/injured-body-part.md)

### SQL referencing this table
- [SQL-023: Retrieve federal awards by worker and status](sql/SQL-023.md)
- [SQL-051: Propagate the primary body part to the injury claim](sql/SQL-051.md)

---

## CL_PPD_BODY_PART_CODE

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | `[unqualified]**` |
| **Purpose** | Reference code table of PPD body parts, cached by `mdlPPD`. |
| **Access pattern** | Direct SQL (`SqlHelper.ResultSetQuery`, outside the criteria pattern) |
| **CRUD operations** | Read |
| **Key columns used** | * (full code table) |
| **Sequence** | N/A |
| **Related tables** | — |
| **Business objects** | `clsPPDBodyParts` |

### Operations referencing this table
- [Code-table caching](operations/code-table-caching.md)

### SQL referencing this table
- [SQL-026: Retrieve PPD body-part code table](sql/SQL-026.md)

---

## CL_PPD_SCHED_DEGREE_AWARD

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | `[unqualified]**` |
| **Purpose** | Effective-dated scheduled PPD degree-award amounts. |
| **Access pattern** | Direct SQL (`SqlHelper.ResultSetQuery`) |
| **CRUD operations** | Read |
| **Key columns used** | EFFECTIVE_DATE, AWARD_PER_DEGREE_AMT |
| **Sequence** | N/A |
| **Related tables** | — |
| **Business objects** | `clsPPDScheduledDegreeAwards` |

### Operations referencing this table
- [PPD award calculation](operations/ppd-award-calc.md)

### SQL referencing this table
- [SQL-027: Retrieve PPD scheduled degree-award table](sql/SQL-027.md)

---

## CL_PPD_UNSCHED_DEGREE_AWARD

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | `[unqualified]**` |
| **Purpose** | Effective-dated, banded PPD unscheduled degree-award amounts. |
| **Access pattern** | Direct SQL (`SqlHelper.ResultSetQuery`) |
| **CRUD operations** | Read |
| **Key columns used** | DEGREE_UPPER_RANGE_NUM, AWARD_PER_DEGREE_AMT, EFFECTIVE_DATE |
| **Sequence** | N/A |
| **Related tables** | — |
| **Business objects** | `clsPPDUnscheduledDegreeAwards` |

### Operations referencing this table
- [PPD award calculation](operations/ppd-award-calc.md)

### SQL referencing this table
- [SQL-028: Retrieve PPD unscheduled degree-award bands](sql/SQL-028.md)

---

## CL_RESERVE_MED_SERV_TYPE_CODE

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | `[unqualified]**` |
| **Purpose** | Medical reserve service-type reference codes. |
| **Access pattern** | Direct SQL (StringBuilder-assembled, criteria constructor) |
| **CRUD operations** | Read |
| **Key columns used** | CODE, CODE_DESCR |
| **Sequence** | N/A |
| **Related tables** | CL_RESERVE_MED_SERV_DESCR_CODE (verified outer join) |
| **Business objects** | `clsServiceTypeCollection` |

### SQL referencing this table
- [SQL-029: Retrieve medical reserve service types](sql/SQL-029.md)

---

## CL_RESERVE_MED_SERV_DESCR_CODE

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | `[unqualified]**` |
| **Purpose** | Medical reserve service description codes joined to service types. |
| **Access pattern** | Direct SQL (StringBuilder-assembled, criteria constructor) |
| **CRUD operations** | Read |
| **Key columns used** | RESERVE_MED_SERV_TYPE_CODE, CODE, CODE_DESCR |
| **Sequence** | N/A |
| **Related tables** | CL_RESERVE_MED_SERV_TYPE_CODE (verified outer join) |
| **Business objects** | `clsServiceTypeCollection` |

### SQL referencing this table
- [SQL-029: Retrieve medical reserve service types](sql/SQL-029.md)

---

## CL_RESERVE_VOC_SERV_COST_CODE

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | `[unqualified]**` |
| **Purpose** | Vocational reserve service-cost reference codes. |
| **Access pattern** | Direct SQL (StringBuilder-assembled, criteria constructor) |
| **CRUD operations** | Read |
| **Key columns used** | CODE, CODE_DESCR |
| **Sequence** | N/A |
| **Related tables** | CL_RESERVE_VOC_SERV_DESCR_CODE (verified outer join) |
| **Business objects** | `clsServiceTypeCollection` |

### SQL referencing this table
- [SQL-030: Retrieve vocational reserve service types](sql/SQL-030.md)

---

## CL_RESERVE_VOC_SERV_DESCR_CODE

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | `[unqualified]**` |
| **Purpose** | Vocational reserve service description codes joined to cost codes. |
| **Access pattern** | Direct SQL (StringBuilder-assembled, criteria constructor) |
| **CRUD operations** | Read |
| **Key columns used** | RESERVE_VOC_SERV_COST_CODE, CODE, CODE_DESCR |
| **Sequence** | N/A |
| **Related tables** | CL_RESERVE_VOC_SERV_COST_CODE (verified outer join) |
| **Business objects** | `clsServiceTypeCollection` |

### SQL referencing this table
- [SQL-030: Retrieve vocational reserve service types](sql/SQL-030.md)

---

## CL_RESERVE_VOC_SERV_TYPE_CODE

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | `[unqualified]**` |
| **Purpose** | Vocational reserve service-type reference codes, cached by `mdlReserveServices`. |
| **Access pattern** | Direct SQL (`SqlHelper.ResultSetQuery`) |
| **CRUD operations** | Read |
| **Key columns used** | * (full code table) |
| **Sequence** | N/A |
| **Related tables** | — |
| **Business objects** | `clsVocationalServiceTypes` |

### Operations referencing this table
- [Code-table caching](operations/code-table-caching.md)

### SQL referencing this table
- [SQL-035: Retrieve vocational service type code table](sql/SQL-035.md)

---

## CL_WORKER_INJURED_BODY_PART

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | `[unqualified]**` |
| **Purpose** | Stores injured body-part rows for a claim, including the primary-body-part indicator. |
| **Access pattern** | Direct SQL (criteria pattern; Create/Retrieve return empty string in `clsWorkerInjuredBodyPart.Criteria`*) |
| **CRUD operations** | Create, Read, Update, Delete |
| **Key columns used** | CLAIM_ID, BODY_PART_CODE, BODY_PART_SIDE_CODE, PRIMARY_BODY_PART_IND, INJURY_NATURE_CODE |
| **Sequence** | N/A |
| **Related tables** | CL_INJURY_CLAIM (inferred, by CLAIM_ID) |
| **Business objects** | `clsWorkerInjuredBodyPart`, `clsWorkerInjuredBodyPartCollection` |

### Operations referencing this table
- [Injured body-part maintenance](operations/injured-body-part.md)

### Business rules referencing this table
- [BR-006: Primary body part is required](business-rules.md#br-006-primary-body-part-is-required)
- [BR-007: Only one primary body part is allowed](business-rules.md#br-007-only-one-primary-body-part-is-allowed)
- [BR-012: Optimistic concurrency contention check](business-rules.md#br-012-optimistic-concurrency-contention-check)

### SQL referencing this table
- [SQL-008: Insert a new injured body-part record](sql/SQL-008.md)
- [SQL-036: Retrieve injured body parts for a claim](sql/SQL-036.md)
- [SQL-050: Update an injured body-part record](sql/SQL-050.md)
- [SQL-062: Delete an injured body-part record](sql/SQL-062.md)

---

## Table relationship diagram

The following diagram shows relationships between tables used by this library.

```mermaid
erDiagram
    CL_AWARD ||--o{ CL_BENEFIT_PAYMENT : "CLAIM_ID, SAIF_AWARD_NUM (inferred)"
    CL_FEDERAL_AWARD ||--o{ CL_BENEFIT_PAYMENT : "CLAIM_ID, SAIF_AWARD_NUM (inferred)"
    CL_FEDERAL_AWARD ||--o{ CL_INJURY_CLAIM : "CLAIM_ID (verified join)"
    CL_BENEFIT_SCHEDULE ||--o{ CL_BENEFIT_PAYMENT : "CLAIM_ID, BENEFIT_PAYMENT_SEQ_NUM (inferred)"
    CL_INJURY_CLAIM ||--o{ CL_WORKER_INJURED_BODY_PART : "CLAIM_ID (inferred)"
    CL_INJURY_CLAIM ||--o{ CL_CLAIM_WORK_STATUS : "CLAIM_ID (inferred)"
    CL_INJURY_CLAIM ||--o{ CL_CLAIM_WORK_RELEASE_STATUS : "CLAIM_ID (inferred)"
    CL_INJURY_CLAIM ||--|| CL_CLAIM_EMPLOYEE_WORK_ADDRESS : "CLAIM_ID (inferred)"
    CL_INJURY_CLAIM ||--o{ CL_1502_DCBS_TRANSFER : "CLAIM_ID (inferred)"
    CL_RESERVE_MED_SERV_TYPE_CODE ||--o{ CL_RESERVE_MED_SERV_DESCR_CODE : "RESERVE_MED_SERV_TYPE_CODE = CODE (verified)"
    CL_RESERVE_VOC_SERV_COST_CODE ||--o{ CL_RESERVE_VOC_SERV_DESCR_CODE : "RESERVE_VOC_SERV_COST_CODE = CODE (verified)"
```

## Related documentation
- [Index](index.md)
- [Overview](overview.md)
- [Architecture](architecture.md)
- [Dependencies](dependencies.md)
- [Operations and processes](operations-processes.md)
- [Business rules](business-rules.md)
- [SQL catalog](sql/index.md)
- [Procedures](procedures/index.md)
- [API reference](api/index.md)

> **Note:** Statements marked with `*` were inferred from code structure, naming
> conventions, or contextual evidence where direct confirmation was not available
> in source artifacts. Statements marked with `**` could not be confirmed; treat
> as unknown until verified.

## Sources
- SAIF.Business.Claim/cls1502Transfer.vb
- SAIF.Business.Claim/clsActiveBenefitSchedule.vb
- SAIF.Business.Claim/clsAwardBenefitPayment.vb
- SAIF.Business.Claim/clsAwardBenefitPaymentCollection.vb
- SAIF.Business.Claim/clsClaimEmployeeWorkAddress.vb
- SAIF.Business.Claim/clsClaimWorkReleaseStatus.vb
- SAIF.Business.Claim/clsClaimWorkStatus.vb
- SAIF.Business.Claim/clsFederalAwardStatus.vb
- SAIF.Business.Claim/clsFederalAwardStatusCollection.vb
- SAIF.Business.Claim/clsPPDBodyParts.vb
- SAIF.Business.Claim/clsPPDScheduledDegreeAwards.vb
- SAIF.Business.Claim/clsPPDUnscheduledDegreeAwards.vb
- SAIF.Business.Claim/clsServiceTypeCollection.vb
- SAIF.Business.Claim/clsSetAwardPaymentPending.vb
- SAIF.Business.Claim/clsVocationalServicesTypes.vb
- SAIF.Business.Claim/clsWorkerInjuredBodyPart.vb
- SAIF.Business.Claim/clsWorkerInjuredBodyPartCollection.vb